Download Oracle Database 11g: Administration I.1z0-052.ExamLabs.2019-03-06.284q.vcex

Vendor: Oracle
Exam Code: 1z0-052
Exam Name: Oracle Database 11g: Administration I
Date: Mar 06, 2019
File Size: 8 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
You notice that the performance of the database has degraded because of frequent checkpoints. 
Which two actions resolve the issue? (Choose two.)
  1. Disable automatic checkpoint tuning
  2. Check the size of the redo log file size and increase the size if it is small
  3. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
  4. Decrease the number of redo log members if there are more than one redo log members available in each redo log group
Correct answer: BC
Question 2
Identify the memory component from which memory may be allocated for:
Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations
  1. Large Pool
  2. Redo Log Buffer
  3. Database Buffer Cache
  4. Program Global Area (PGA)
Correct answer: A
Question 3
You executed the following command to create a tablespace called SALES_DATA:
  
Which two statements are true about the SALES_DATA tablespace? (Choose two)
  1. The database automatically determines the extent-sizing policy for the tablespace.
  2. The segments are automatically shrunk when the contents are removed from them.
  3. The allocation of extents within the tablespace is managed through the dictionary tables.
  4. The space utilization description of the data blocks in segments is recorded in bitmap blocks.
  5. The space utilization description of the data blocks in segments is managed through free lists.
Correct answer: AD
Question 4
In which of the scenario will the DBA perform recovery? (Choose all that apply.)
  1. The alert log file is corrupted.
  2. A tablespace is accidentally dropped.
  3. One of the redo log members is corrupted.
  4. A database user terminates the session abnormally.
  5. The hard disk on which the data files is stored is corrupted.
Correct answer: BE
Question 5
You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode. 
Given below are the steps to accomplish the task in random order:
  1. Shut down the instance. 
  2. Execute the ALTER DATABASE ARCHIVELOG command. 
  3. Start up the instance and mount the database. 
  4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1. 
  5. Open the database. 
Which is the correct sequence of steps for accomplishing the task?
  1. 4, 1, 3, 2, 5
  2. 1, 3, 4, 5, 2
  3. 1, 3, 2, 5; 4 not required
  4. 4, 1, 5, 2; 3 not required
  5. 1, 3, 4, 5; 2 not required
Correct answer: C
Question 6
You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file. 
View the Exhibit and check the commands executed. 
  
What is the location of the alert_orcl.log file?
  1. ORACLE_HOME/dbs
  2. ORACEL_HOME/rdbms
  3. /u01/app/oracle/admin/orcl/adump
  4. /u01/app/oracle/flash_recovery_area
  5. ORACLE_BASE/diag/rdbms/orcl/alert
  6. ORACLE_BASE/diag/rdbms/orcl/orcl/trace
Correct answer: F
Question 7
See the Exhibit:
  
Which statements are true regarding the USERS tablespace? (Choose all that apply.)
  1. A bitmap is used to record free extents
  2. Free extents information is managed within the tablespace
  3. Free extents information is managed in the SYSAUX tablespace
  4. The data dictionary tables are updated when extents are allocated or deallocated
Correct answer: AB
Question 8
Examine the values for the following initialization parameters:
  • FAST_START_MTTR_TARGET=0 
  • LOG_CHECKPOINT_INTERVAL=0 
Which two will be the implications of these values in your database? (Choose two.)
  1. The SGA advisor will be disabled
  2. The MTTR advisor will be disabled
  3. Automatic checkpoint tuning will be disabled
  4. Checkpoint information will not be written to the alert log file
Correct answer: BC
Question 9
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. 
What is the impact of this setting?
  1. Optimizer statistics are collected automatically.
  2. Only timed operating system (OS) statistics and plan execution statistics are collected.
  3. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
  4. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.
  5. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
Correct answer: C
Question 10
You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value. 
Which action would help to use the previous set of statistics on the objects?
  1. Restore statistics from statistics history.
  2. Reduce the optimizer statistics retention period by 2 days.
  3. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
  4. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.
Correct answer: A
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!